CREATE VIEW mt.ots_mx_customiz AS
	SELECT
		fldnum,
		title,   -- change here for different language ex. title5 title for French
		"row",
		col,
		len,
		case when fldnum='2340' then 3
		     else fform
		end fform
	FROM
		mt.me2_customiz
	WHERE
		desktop = 'TOOLS' AND   -- change DEFAULT to a different desktop?
		suppressed <> 'Y' AND
		fldnum < '5000' AND
		fform in ('0','2','3','4','5','6')
		or (fldnum='2340' and desktop='DEFAULT' AND suppressed <> 'Y');	-- different desktop?		
COMMENT ON VIEW mt.ots_mx_customiz IS 'MET/EX v7 Screen Customization';
INSERT INTO mt.ots_objects(object_name,version,creation_date) VALUES ('ots_mx_customiz','4',now(*));	
GRANT SELECT ON mt.ots_mx_customiz TO PUBLIC;COMMIT;
